package com.test;

import com.dao.OrderDao;
import com.dao.impl.BaseDao;
import com.dao.impl.OrderDaoImpl;
import com.pojo.Order;
import com.pojo.OrderItem;
import org.junit.Test;

import java.sql.Date;

public class test extends BaseDao {
    @Test
    public void test1(){
        String sql = "select `create_time` FROM t_order WHERE `order_id`='16519752831371'";
        System.out.println(queryForOne(Date.class, sql));
    }

    @Test
    public void test2(){
        String sql = "select `id`,`name`,`count`,`price`,`total_price`,`order_id` from t_order_item where order_id=?";
        System.out.println(queryForList(OrderItem.class,sql,"16519752831371"));
    }

}
